At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert thresholds in Redgate Monitor and decided to write a little about this. This is part...
2026-04-06 (first published: 2026-03-23)
190 reads
A while back I posted about a couple of side projects that I’ve been working on when I get the chance. One of those was the Burrito Bot…a bot...
2026-04-06 (first published: 2026-03-27)
335 reads
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this feature encrypts a physical layer of Database files Data/log files protection at Disk / storage...
2026-04-04 (first published: 2026-04-03)
29 reads
Only a little break for me. I’m actually heading to Las Vegas today for the Red Rock Rave volleyball tournament with a team of 13 year olds. We’ve been...
2026-04-03
12 reads
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
Originally published in 2023, this post never made it into Google's index, so I'm republishing it...
2026-04-03 (first published: 2026-03-26)
355 reads
We’re coming back to New York, which is exciting for me. I love NYC. The Redgate Summit 2026 – New York City comes back on May 5, 2026. You...
2026-04-03 (first published: 2026-03-25)
162 reads
Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I...
2026-04-01 (first published: 2026-03-18)
219 reads
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL Server 2025. The latest version of mirroring that uses the SQL Server Change Feed is...
2026-04-01 (first published: 2026-03-24)
287 reads
I am guilty as charged. The quote was in reference to how people argue about details in fitness or finances that are more detailed than is useful to them....
2026-03-30 (first published: 2026-03-13)
187 reads
As someone who works in DevOps, I’m always focused on creating systems that are efficient, scalable, and reliable. But when it comes to the cloud, one critical piece often...
2026-03-30 (first published: 2026-03-15)
192 reads
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers